IN-14 Inventory Margin
This report will show you the profit on items. It will show you what markup table you are using for each item, the calculated list prices based on the markup table as well as the current list price, the difference between the two and the actual profit margin seen for each item. This will help you identify list price errors or where list prices potentially need to be revised.
Report Parameters
- LOCATION: This option will let you select one or multiple locations.
- SUPPLIER: This option will let you select one or multiple suppliers.
- OEM: This option will let you select one or multiple OEMs (Original Equipment Manufacturer). The OEM is used to define groups of brands. If one buyer is responsible for a handful of brands, you can create an OEM in the OEM table and then assign the OEM to each brand. This way one single OEM of ‘WP’ can pull Maytag, Jenn air, and Whirlpool, etc.
- BRAND: This option will let you select one or multiple brands.
- PRODUCT: This option will let you select one or multiple products.
- INVENTORY TYPE: This option will let you select one or multiple inventory types.
- STOCK/NON-STOCK: This option will let you run the report for stock, non-stock, or both stock and non-stock items.
- ITEMS FROM and TO: With this option, you can run the report for all items, a range of items or just one item.
You can export the report to Excel by clicking on the Excel button.